Format Cell

J

j4ymf

Well-known Member
Joined
Apr 28, 2003
Messages
776
Office Version
  1. 365
Platform
  1. Windows
Good morning

What am i doing wrong?
Im looking to add a 1 after a selected cell and i would normally format cell and the use 0" 1" but thats not working

many thanks

1736409981280.png
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
You are trying to format "text" using a number format.
Try this but if you are going to enter numbers as well as text we will need to tweak it.
@" 1"
 
Upvote 0
Solution
Hello Alex Blakenburg, thats great thank you much apprichated
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Address to multiple cell
Replies
6
Views
118
patv
P
A
  • Question Question
help with a search function
Replies
8
Views
150
Cubist
Cubist
Dan Wilson
  • Solved
Format help
Replies
7
Views
195
Alex Blakenburg
A
N
  • Solved
How to change 1 cell value based on the value of another cell
Replies
3
Views
92
Joe4
Joe4
I
  • Solved
Show message if specific text in cell & date check are met
3 4 5
Replies
42
Views
1K
ipbr21054
I

Forum statistics

Threads
1,226,065
Messages
6,188,678
Members
453,490
Latest member
amru

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top