| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replace Scientific Format
How to replace 1,50E-03A with 1,50mA?
-- regards/pozdrav! Berislav |
|
#2
|
|||
|
|||
|
two ways You can make your own format for cells format-cells tab numbers select custom and make a mask like "0,00mA" and by VBA format$(yournumber,"0,00mA") -- Dnereb ------------------------------------------------------------------------ Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182 View this thread: http://www.excelforum.com/showthread...hreadid=398079 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i replace ( with / without changing format to fraction | Excel Worksheet Functions | |||
| Automatic scientific format when entering 5E100 | Excel Discussion (Misc queries) | |||
| Using Replace to Format Negative Numbers | Excel Discussion (Misc queries) | |||
| csv converting numbers to scientific format | Excel Discussion (Misc queries) | |||
| Global fix for scientific number format? | Excel Discussion (Misc queries) | |||
Linear Mode
