| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I format a cell to read a blood pressure?
-- IzzyNeedsHelp |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I format a cell to read a blood pressure?
Use two cells--in two different columns.
It'll make your life easier if you want to do arithmetic with the top or bottom numbers. Izzy wrote: -- IzzyNeedsHelp -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I format a cell to read a blood pressure?
ps. If you really wanted to use a single cell (I wouldn't!), you can preformat
the cell as Text, then do the data entry. Or you could prefix your entry with an apostrophe: '120/80 Izzy wrote: -- IzzyNeedsHelp -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I format a cell to read a blood pressure?
format the cells as Text, then enter it like 120/80, then use =LEFT(a1,3) and
=right(a1,2) to work with the two numbers. "Izzy" wrote: -- IzzyNeedsHelp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you get more chart days on Blood pressure tracker | Charts and Charting in Excel | |||
| Blood Pressure Chats in Excell | Charts and Charting in Excel | |||
| Chart to monitor Blood Pressure readings and date | Charts and Charting in Excel | |||
| Calculate change in blood pressure | Excel Worksheet Functions | |||
| blood pressure charting | Charts and Charting in Excel | |||
Linear Mode
