Formatting 2500 to 25.00

hhazlett

New Member
Joined
Dec 16, 2005
Messages
1
Hi all - I'm new to this site, nice to meet ya :)
I have used "#"".""#0" to format 2500 to read 25.00 in the cell, but the formula bar still reads the value as 2500. How can I change that to 25.00?
Thanks for your help.
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
The formula bar will always show the actual value in the cell, in this case 2500.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,035
Messages
5,569,784
Members
412,292
Latest member
The Bear named Joe
Top