Show the decimal point as( :) instead of (.)

rmtaylor

Board Regular
Joined
Feb 17, 2002
Messages
155
Hi
I have been trying without success to make a sheet I have been working on show the decimal point as :)) instead of (.) The best result I have managed is (.: )by entering (0. ":" 00) in the custom box in number formatting. I would be grateful if anyone can help as my efforts does not look very professional.
This message was edited by rmtaylor on 2002-04-21 01:07
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
erm soory to hear that, i fancy not allowuing Excel to solve this hy not windows...

Ok riginal setting in the control pannel ahs wonderful goodies to ply with.

try under number tab these is a decimal setting to amend to :

then click ok.

caution stays until re set.....

*MARKER DECIMAL POINT*
 
Upvote 0
Say your source value in A1 includes (.):

=SUBSTITUTE(A1,".",":")

What do you think?
This message was edited by smozgur on 2002-04-21 05:06
This message was edited by smozgur on 2002-04-21 05:06
 
Upvote 0
Smoz,

I was going to suggest that but try multiplying the result by 5 or something, it brings back a weird result

:eek:
 
Upvote 0
Chris,

sure, this solution is just for viewing cell data required format, not for using the result in calculation.
 
Upvote 0
Chris,

If it is necessary to use that cell's original value reverse is possible:

A1 => =25.14

A2 => =SUBSTITUTE(A1,".",":")

A3 => =SUBSTITUTE(A2,":",".")*5

Yes?
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,570
Latest member
rik81h

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